﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.Master" AutoEventWireup="true" CodeBehind="StatisticalOfDepartBook.aspx.cs" Inherits="MyHospital.web.StatisticalOfDepartBook" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
    <style>
        .total {
            margin-right: 550px;
        }
         .total p {
            font-size:14px;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder2" runat="server">
    <div class="total">
    <p>各科室预约人数</p>
    <asp:Chart ID="Chart1" runat="server" DataSourceID="SqlDataSource1">
        <Series>
            <asp:Series Name="Series1" XValueMember="departName" YValueMembers="Expr1"></asp:Series>
        </Series>
        <ChartAreas>
            <asp:ChartArea Name="ChartArea1"></asp:ChartArea>
        </ChartAreas>
    </asp:Chart>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyHospitalConnectionString2 %>" SelectCommand="SELECT Department.departName, COUNT(*) AS Expr1 FROM BookingInfor INNER JOIN Department ON BookingInfor.departId = Department.departId GROUP BY Department.departName"></asp:SqlDataSource>
   </div>
</asp:Content>
